C#。要求能进行保存,然后我试了两个礼拜了。就是不行,只能保存日期,班次和数量保存不进去。
using System;
using System.Data;
using System.Web.UI.WebControls;
using TaiJie;
using TaiJie.abcx;namespace xheap.Sales
{
public partial class SalesPlanEdit : System.Web.UI.Page
{
DataBase myDb = new DataBase();
DataRow dr;
//上一个页面地址
string PreUrl;
//获取ID、获取的日期、获取的班
string strE, strData, sqlwhere;
bool IsEdit = false;
protected void Page_Load(object sender, EventArgs e)
{
// 判断登录用户权限
FormAccess myAccess = new FormAccess("ShippingPlan.aspx", this);
myAccess.Verify(FormAccess.AccessType.Write); // 页面中文名称,用于导航条中文显示
string strTitle;
// 得到个人设置的模块名
string ModuleName = TaiJie.xheap.Measure.ToString();
//获取ID
strE = FlatBase.ToString(Request["e"]);
//获取日期
strData = FlatBase.ToString(Request["d"]); // 前一页的文件名
PreUrl = "ShippingPlan.aspx?d=" + strData;
if (strE == "1")
PreUrl = "ShippingPlanDetail.aspx?d=" + strData;
//检验ID是否在数据库里面存在 sqlwhere = "if_remove=0 and plan_date ='" + strData + "'";
dr = myDb.GetDataRow("Tb_ShippingPlan", sqlwhere);
if (dr != null)
{
strTitle = "编辑盐种需求计划";
//RecordEdit1.ReadOnlyField = "plan_date";
IsEdit = true;
}
else
{
strTitle = "添加盐种需求计划";
} UpperTip1.Title = strTitle;
UpperTip1.TipLabel.Text = strTitle;
UpperTip1.DataBind(); this.UpperTip2.Title = "";
this.UpperTip2.DataBind(); //设置网页标题
//头控件绑定
this.Page.Title = strTitle;
this.Header1.SetBackGround(htmlBody);
this.Header1.Navigation.PageTitle = strTitle;
this.Header1.Navigation.PrePageUrl = ModuleName + "/" + PreUrl;
this.Header1.DataBind();
//尾控件绑定
this.Footer1.Navigation.PageTitle = strTitle;
this.Footer1.Navigation.PrePageUrl = ModuleName + "/" + PreUrl;
this.Footer1.DataBind();
//绑定表
RecordEdit1.TableName = "Tb_ShippingPlan";
RecordEdit1.DataBind();
//消
DataTable dtSalesDaily = myDb.GetDataTable("Tb_ShippingPlan", "1=0");
string[] WClass = { "晚班", "早班", "中班" };
DataRow drSalesDaily;
for (int i = 0; i < WClass.Length; i++)
{
drSalesDaily = dtSalesDaily.NewRow();
drSalesDaily["work_class"] = WClass[i];
drSalesDaily["plan_id"] = i;
dtSalesDaily.Rows.Add(drSalesDaily);
}
if (dr != null)
{
string SQlwhere = "if_remove=0 and plan_date=" + "'" + strData + "'";
DataTable dtDaily = myDb.GetDataTable("Tb_ShippingPlan", SQlwhere);
DataRow[] drDaily;
for (int i = 0; i < dtDaily.Rows.Count; i++)
{
drDaily = dtSalesDaily.Select("work_class='" + dtDaily.Rows[i]["work_class"] + "'");
drDaily[0]["plan_id"] = FlatBase.ToInt(dtDaily.Rows[i]["plan_id"]);
drDaily[0]["large_package"] = FlatBase.ToDecimal(dtDaily.Rows[i]["large_package"]);
drDaily[0]["small_package"] = FlatBase.ToDecimal(dtDaily.Rows[i]["small_package"]);
}
}
RecordView1.DataSource = dtSalesDaily;
RecordView1.DataKeyField = "plan_id";
RecordView1.SetFieldInfo("work_class", "班次", EnumInfo.ViewType.Text);
RecordView1.SetFieldInfo("large_package", "大包盐种及数量", EnumInfo.ViewType.Input, 170, 0);
RecordView1.SetFieldInfo("small_package", "小包盐种及数量",EnumInfo.ViewType.Input,170,0);
RecordView1.FieldFrom = EnumInfo.FieldFrom.Page;
RecordView1.AllowPaging = false;
RecordView1.DataBind();
if (!IsPostBack)
{
}
}
protected void BtnOK_Click(object sender, EventArgs e)
{
if (RecordEdit1.Update("plan_id"))
{
Save_ShippingPlan(); Response.Redirect(PreUrl);
}
else
{
this.UpperTip1.TipLabel.CssClass = "RedCue";
}
}
protected void Save_ShippingPlan()
{
string[] small_package = this.RecordView1.GetInputedText("small_package");
string[] large_package = this.RecordView1.GetInputedText("large_package");
string KeyValue = this.RecordView1.DataKeyValueString;
string[] arrKey = KeyValue.Split(',');
BatchSave myBsBo = new BatchSave();
if (IsEdit == true)
{
myBsBo.Bind("Tb_ShippingPlan");
} else
myBsBo.Bind("Tb_ShippingPlan", sqlwhere);
DataTable dtShippingPlan = myBsBo.GetDataTable;
DataView dvShippingPlan = dtShippingPlan.DefaultView;
DataTable dtDailyShippingPlan = RecordView1.DataSource;
//编辑时数据填充
for (int iRows = 0; iRows < dtDailyShippingPlan.Rows.Count; iRows++)
{
DataRow drShippingPlan;
dvShippingPlan.RowFilter = "plan_id=" + arrKey[iRows];
if (dvShippingPlan.Count > 0)
drShippingPlan = dvShippingPlan[0].Row;
else
{
drShippingPlan = dtShippingPlan.NewRow();
dtShippingPlan.Rows.Add(drShippingPlan);
}
drShippingPlan["work_class"] = dtDailyShippingPlan.Rows[iRows]["work_class"];
drShippingPlan["small_package"] = FlatBase.ToDecimal(small_package[iRows]);
drShippingPlan["large_package"] = FlatBase.ToDecimal(large_package[iRows]);
if (IsEdit == false)
{
drShippingPlan["creator_id"] = SysSession.UserID;
drShippingPlan["creator_name"] = SysSession.UserName;
drShippingPlan["created_time"] = DateTime.Now;
}
drShippingPlan["updater_id"] = SysSession.UserID;
drShippingPlan["updater_name"] = SysSession.UserName;
drShippingPlan["updated_time"] = DateTime.Now;
}
myBsBo.SetDataTable = dtShippingPlan;
myBsBo.Update();
}
protected void BtnCancle_Click1(object sender, EventArgs e)
{
Response.Redirect(PreUrl);
}
}
}
using System;
using System.Data;
using System.Web.UI.WebControls;
using TaiJie;
using TaiJie.abcx;namespace xheap.Sales
{
public partial class SalesPlanEdit : System.Web.UI.Page
{
DataBase myDb = new DataBase();
DataRow dr;
//上一个页面地址
string PreUrl;
//获取ID、获取的日期、获取的班
string strE, strData, sqlwhere;
bool IsEdit = false;
protected void Page_Load(object sender, EventArgs e)
{
// 判断登录用户权限
FormAccess myAccess = new FormAccess("ShippingPlan.aspx", this);
myAccess.Verify(FormAccess.AccessType.Write); // 页面中文名称,用于导航条中文显示
string strTitle;
// 得到个人设置的模块名
string ModuleName = TaiJie.xheap.Measure.ToString();
//获取ID
strE = FlatBase.ToString(Request["e"]);
//获取日期
strData = FlatBase.ToString(Request["d"]); // 前一页的文件名
PreUrl = "ShippingPlan.aspx?d=" + strData;
if (strE == "1")
PreUrl = "ShippingPlanDetail.aspx?d=" + strData;
//检验ID是否在数据库里面存在 sqlwhere = "if_remove=0 and plan_date ='" + strData + "'";
dr = myDb.GetDataRow("Tb_ShippingPlan", sqlwhere);
if (dr != null)
{
strTitle = "编辑盐种需求计划";
//RecordEdit1.ReadOnlyField = "plan_date";
IsEdit = true;
}
else
{
strTitle = "添加盐种需求计划";
} UpperTip1.Title = strTitle;
UpperTip1.TipLabel.Text = strTitle;
UpperTip1.DataBind(); this.UpperTip2.Title = "";
this.UpperTip2.DataBind(); //设置网页标题
//头控件绑定
this.Page.Title = strTitle;
this.Header1.SetBackGround(htmlBody);
this.Header1.Navigation.PageTitle = strTitle;
this.Header1.Navigation.PrePageUrl = ModuleName + "/" + PreUrl;
this.Header1.DataBind();
//尾控件绑定
this.Footer1.Navigation.PageTitle = strTitle;
this.Footer1.Navigation.PrePageUrl = ModuleName + "/" + PreUrl;
this.Footer1.DataBind();
//绑定表
RecordEdit1.TableName = "Tb_ShippingPlan";
RecordEdit1.DataBind();
//消
DataTable dtSalesDaily = myDb.GetDataTable("Tb_ShippingPlan", "1=0");
string[] WClass = { "晚班", "早班", "中班" };
DataRow drSalesDaily;
for (int i = 0; i < WClass.Length; i++)
{
drSalesDaily = dtSalesDaily.NewRow();
drSalesDaily["work_class"] = WClass[i];
drSalesDaily["plan_id"] = i;
dtSalesDaily.Rows.Add(drSalesDaily);
}
if (dr != null)
{
string SQlwhere = "if_remove=0 and plan_date=" + "'" + strData + "'";
DataTable dtDaily = myDb.GetDataTable("Tb_ShippingPlan", SQlwhere);
DataRow[] drDaily;
for (int i = 0; i < dtDaily.Rows.Count; i++)
{
drDaily = dtSalesDaily.Select("work_class='" + dtDaily.Rows[i]["work_class"] + "'");
drDaily[0]["plan_id"] = FlatBase.ToInt(dtDaily.Rows[i]["plan_id"]);
drDaily[0]["large_package"] = FlatBase.ToDecimal(dtDaily.Rows[i]["large_package"]);
drDaily[0]["small_package"] = FlatBase.ToDecimal(dtDaily.Rows[i]["small_package"]);
}
}
RecordView1.DataSource = dtSalesDaily;
RecordView1.DataKeyField = "plan_id";
RecordView1.SetFieldInfo("work_class", "班次", EnumInfo.ViewType.Text);
RecordView1.SetFieldInfo("large_package", "大包盐种及数量", EnumInfo.ViewType.Input, 170, 0);
RecordView1.SetFieldInfo("small_package", "小包盐种及数量",EnumInfo.ViewType.Input,170,0);
RecordView1.FieldFrom = EnumInfo.FieldFrom.Page;
RecordView1.AllowPaging = false;
RecordView1.DataBind();
if (!IsPostBack)
{
}
}
protected void BtnOK_Click(object sender, EventArgs e)
{
if (RecordEdit1.Update("plan_id"))
{
Save_ShippingPlan(); Response.Redirect(PreUrl);
}
else
{
this.UpperTip1.TipLabel.CssClass = "RedCue";
}
}
protected void Save_ShippingPlan()
{
string[] small_package = this.RecordView1.GetInputedText("small_package");
string[] large_package = this.RecordView1.GetInputedText("large_package");
string KeyValue = this.RecordView1.DataKeyValueString;
string[] arrKey = KeyValue.Split(',');
BatchSave myBsBo = new BatchSave();
if (IsEdit == true)
{
myBsBo.Bind("Tb_ShippingPlan");
} else
myBsBo.Bind("Tb_ShippingPlan", sqlwhere);
DataTable dtShippingPlan = myBsBo.GetDataTable;
DataView dvShippingPlan = dtShippingPlan.DefaultView;
DataTable dtDailyShippingPlan = RecordView1.DataSource;
//编辑时数据填充
for (int iRows = 0; iRows < dtDailyShippingPlan.Rows.Count; iRows++)
{
DataRow drShippingPlan;
dvShippingPlan.RowFilter = "plan_id=" + arrKey[iRows];
if (dvShippingPlan.Count > 0)
drShippingPlan = dvShippingPlan[0].Row;
else
{
drShippingPlan = dtShippingPlan.NewRow();
dtShippingPlan.Rows.Add(drShippingPlan);
}
drShippingPlan["work_class"] = dtDailyShippingPlan.Rows[iRows]["work_class"];
drShippingPlan["small_package"] = FlatBase.ToDecimal(small_package[iRows]);
drShippingPlan["large_package"] = FlatBase.ToDecimal(large_package[iRows]);
if (IsEdit == false)
{
drShippingPlan["creator_id"] = SysSession.UserID;
drShippingPlan["creator_name"] = SysSession.UserName;
drShippingPlan["created_time"] = DateTime.Now;
}
drShippingPlan["updater_id"] = SysSession.UserID;
drShippingPlan["updater_name"] = SysSession.UserName;
drShippingPlan["updated_time"] = DateTime.Now;
}
myBsBo.SetDataTable = dtShippingPlan;
myBsBo.Update();
}
protected void BtnCancle_Click1(object sender, EventArgs e)
{
Response.Redirect(PreUrl);
}
}
}
解决方案 »
- 逻辑题
- 调用EXE
- 急,求助关于TeeChart问题,请高手赐教。
- C#winform中的datagrid如何保持最右侧的边界线不动,就是在手动调列宽的时候,不会在datagrid中出现空白
- 怎么样使DataGrid列的宽度随着列显示的内容自动变化呢?急。。。
- 程序怎么了,着急死了,突如其来,大家帮忙!!!!!!!!!!!!!!!1
- 咋回事哩???未将对象引用设置到对象的实例
- 关于 DataTable 的一个问题
- C# 标准音是怎么读的?
- 这样的sql语句怎么写?
- 动态构造列,用dev gridcontrol绑定后,控件数据显示不出来
- 错误信息:列的FIllWeight值总和不能超过65535
审批:申克
要求做到这样,并且可以保存,求助大侠帮我看看程序里哪个条件写的不对