protected void RadGrid1_PageIndexChanged(object sender, Telerik.Web.UI.GridPageChangedEventArgs e)
{
Maticsoft.Model.ReplacementRecord molpur = bllpur.GetModel(Request.QueryString["ID"].ToString());//引用id所在行的数据
if (molpur != null)
{
Maticsoft.Model.ReplacementRecord molpur1 = bllpur.GetModel1(molpur.ReplacementRecordID);//引用id所在行的数据
Maticsoft.BLL.ReplacementRecord bllpur1 = new Maticsoft.BLL.ReplacementRecord();
RadGrid1.Rebind();
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.ReplacementRecord DataRowToModel(DataRow row)
{
Maticsoft.Model.ReplacementRecord model = new Maticsoft.Model.ReplacementRecord();
if (row != null)
{
if (row["ReplacementRecordID"] != null)
{
model.ReplacementRecordID = row["ReplacementRecordID"].ToString();
}
if (row["ReplacementID"] != null)
{
model.ReplacementID = row["ReplacementID"].ToString();
}
if (row["ReplacementName"] != null)
{
model.ReplacementName = row["ReplacementName"].ToString();
}
if (row["ReplacementLendTime"] != null && row["ReplacementLendTime"].ToString() != "")
{
model.ReplacementLendTime = DateTime.Parse(row["ReplacementLendTime"].ToString());
}
if (row["ReplacementBackTime"] != null && row["ReplacementBackTime"].ToString() != "")
{
model.ReplacementBackTime = DateTime.Parse(row["ReplacementBackTime"].ToString());
}
if (row["UserID"] != null)
{
model.UserID = row["UserID"].ToString();
}
if (row["GGG1"] != null)
{
model.GGG1 = row["GGG1"].ToString();
}
if (row["GGG2"] != null)
{
model.GGG2 = row["GGG2"].ToString();
}
if (row["GGG3"] != null)
{
model.GGG3 = row["GGG3"].ToString();
}
if (row["GGG4"] != null)
{
model.GGG4 = row["GGG4"].ToString();
}
if (row["GGG5"] != null)
{
model.GGG5 = row["GGG5"].ToString();
}
}
return(model);
}
/*
*/
public Maticsoft.Model.ReplacementRecord GetModelJYF2(string ReplacementID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ");
strSql.Append(" * ");
strSql.Append(" from ReplacementRecord a,Declaration b ");
strSql.Append(" where b.ReplacementID='" + ReplacementID + "'and a.ReplacementID = b.ReplacementID ");
Maticsoft.Model.ReplacementRecord model = new Maticsoft.Model.ReplacementRecord();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public Maticsoft.Model.ReplacementRecord GetModel1(string ReplacementRecordID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ");
strSql.Append(" ReplacementRecordID,ReplacementID,ReplacementName,ReplacementLendTime,ReplacementBackTime,UserID,GGG1,GGG2,GGG3,GGG4,GGG5 ");
strSql.Append(" from ReplacementRecord ");
strSql.Append(" where ReplacementRecordID='" + ReplacementRecordID + "' ");
Maticsoft.Model.ReplacementRecord model = new Maticsoft.Model.ReplacementRecord();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
protected void RadGrid1_ItemCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e)
{
string id = e.CommandArgument.ToString();
if (e.CommandName == "Chanel")
{
Response.Redirect("RepairEdit.aspx?ID=" + e.CommandArgument + "");//跳转修改页面
}
if (e.CommandName == "UP")
{
Declaration_Mol = Declaration_Bll.GetModel(e.CommandArgument.ToString());
Declaration_Mol.DeclarationState = "装备中心待受理";
Declaration_Bll.Update(Declaration_Mol);
DataLoad();
RadGrid1.Rebind();
}
if (e.CommandName == "Return")
{
Declaration_Mol = Declaration_Bll.GetModel(e.CommandArgument.ToString());
Declaration_Mol.DeclarationState = "未上报";
Declaration_Bll.Update(Declaration_Mol);
DataLoad();
RadGrid1.Rebind();
}
if (e.CommandName == "CheckOK")
{
Declaration_Mol = Declaration_Bll.GetModel(e.CommandArgument.ToString());
Declaration_Mol.DeclarationState = "维修完成";
Declaration_Bll.Update(Declaration_Mol);
DataLoad();
RadGrid1.Rebind();
}
if (e.CommandName == "CheckBack")
{
Declaration_Mol = Declaration_Bll.GetModel(e.CommandArgument.ToString());
Replacement_Mol = Replacement_Bll.GetModelJYF(Declaration_Mol.ReplacementID);
if (Declaration_Mol.ReplacementUse != "否")
{
Replacement_Mol.ReplacementState = "未借出";
Replacement_Bll.Update(Replacement_Mol);
ReplacementRecord_Mol = ReplacementRecord_Bll.GetModelJYF2(Declaration_Mol.ReplacementID);
ReplacementRecord_Mol.ReplacementBackTime = DateTime.Now;
ReplacementRecord_Bll.Update(ReplacementRecord_Mol);
}
Declaration_Mol.DeclarationState = "报修单位已取回";
Declaration_Bll.Update(Declaration_Mol);
DataLoad();
RadGrid1.Rebind();
}
if (e.CommandName == "Repair2")
{
Lable_xxx.Text = e.CommandArgument.ToString();
//Response.Redirect("RepairBackAdd.aspx?ID=" + e.CommandArgument + "");
}
if (e.CommandName == "CheckRepair2Back")
{
Declaration_Mol = Declaration_Bll.GetModel(e.CommandArgument.ToString());
Replacement_Mol = Replacement_Bll.GetModelJYF(Declaration_Mol.ReplacementID);
if (Declaration_Mol.ReplacementUse != "否")
{
Replacement_Mol.ReplacementState = "未借出";
Replacement_Bll.Update(Replacement_Mol);
ReplacementRecord_Mol.ReplacementBackTime = DateTime.Now;
ReplacementRecord_Bll.Update(ReplacementRecord_Mol);
}
Declaration_Mol.DeclarationState = "报修单位已取回(返修)";
Declaration_Bll.Update(Declaration_Mol);
DataLoad();
RadGrid1.Rebind();
}
if (e.CommandName == "CheckRepair2OK")
{
Declaration_Mol = Declaration_Bll.GetModel(e.CommandArgument.ToString());
Declaration_Mol.DeclarationState = "返修完成";
Declaration_Bll.Update(Declaration_Mol);
DataLoad();
RadGrid1.Rebind();
}
if (e.CommandName == "Down")
{
Response.Redirect("RepairReport.aspx?ID=" + e.CommandArgument + "");//跳转报表页面
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Maticsoft.Model.ReplacementRecord model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.ReplacementRecordID != null)
{
strSql1.Append("ReplacementRecordID,");
strSql2.Append("'" + model.ReplacementRecordID + "',");
}
if (model.ReplacementID != null)
{
strSql1.Append("ReplacementID,");
strSql2.Append("'" + model.ReplacementID + "',");
}
if (model.ReplacementName != null)
{
strSql1.Append("ReplacementName,");
strSql2.Append("'" + model.ReplacementName + "',");
}
if (model.ReplacementLendTime != null)
{
strSql1.Append("ReplacementLendTime,");
strSql2.Append("'" + model.ReplacementLendTime + "',");
}
if (model.ReplacementBackTime != null)
{
strSql1.Append("ReplacementBackTime,");
strSql2.Append("'" + model.ReplacementBackTime + "',");
}
if (model.UserID != null)
{
strSql1.Append("UserID,");
strSql2.Append("'" + model.UserID + "',");
}
if (model.GGG1 != null)
{
strSql1.Append("GGG1,");
strSql2.Append("'" + model.GGG1 + "',");
}
if (model.GGG2 != null)
{
strSql1.Append("GGG2,");
strSql2.Append("'" + model.GGG2 + "',");
}
if (model.GGG3 != null)
{
strSql1.Append("GGG3,");
strSql2.Append("'" + model.GGG3 + "',");
}
if (model.GGG4 != null)
{
strSql1.Append("GGG4,");
strSql2.Append("'" + model.GGG4 + "',");
}
if (model.GGG5 != null)
{
strSql1.Append("GGG5,");
strSql2.Append("'" + model.GGG5 + "',");
}
strSql.Append("insert into ReplacementRecord(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
int rows = DbHelperSQL.ExecuteSql(strSql.ToString());
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.ReplacementRecord model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ReplacementRecord set ");
if (model.ReplacementID != null)
{
strSql.Append("ReplacementID='" + model.ReplacementID + "',");
}
else
{
strSql.Append("ReplacementID= null ,");
}
if (model.ReplacementName != null)
{
strSql.Append("ReplacementName='" + model.ReplacementName + "',");
}
else
{
strSql.Append("ReplacementName= null ,");
}
if (model.ReplacementLendTime != null)
{
strSql.Append("ReplacementLendTime='" + model.ReplacementLendTime + "',");
}
else
{
strSql.Append("ReplacementLendTime= null ,");
}
if (model.ReplacementBackTime != null)
{
strSql.Append("ReplacementBackTime='" + model.ReplacementBackTime + "',");
}
else
{
strSql.Append("ReplacementBackTime= null ,");
}
if (model.UserID != null)
{
strSql.Append("UserID='" + model.UserID + "',");
}
else
{
strSql.Append("UserID= null ,");
}
if (model.GGG1 != null)
{
strSql.Append("GGG1='" + model.GGG1 + "',");
}
else
{
strSql.Append("GGG1= null ,");
}
if (model.GGG2 != null)
{
strSql.Append("GGG2='" + model.GGG2 + "',");
}
else
{
strSql.Append("GGG2= null ,");
}
if (model.GGG3 != null)
{
strSql.Append("GGG3='" + model.GGG3 + "',");
}
else
{
strSql.Append("GGG3= null ,");
}
if (model.GGG4 != null)
{
strSql.Append("GGG4='" + model.GGG4 + "',");
}
else
{
strSql.Append("GGG4= null ,");
}
if (model.GGG5 != null)
{
strSql.Append("GGG5='" + model.GGG5 + "',");
}
else
{
strSql.Append("GGG5= null ,");
}
int n = strSql.ToString().LastIndexOf(",");
strSql.Remove(n, 1);
strSql.Append(" where ReplacementRecordID='" + model.ReplacementRecordID + "' ");
int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString());
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
