/// <summary>
/// 得到一个对象实体
/// </summary>
public LogMainTable DataRowToModel(DataRow row)
{
LogMainTable model = new LogMainTable();
if (row != null)
{
if (row["LogID"] != null && row["LogID"].ToString() != "")
{
model.LogID = row["LogID"].ToString();
}
if (row["AxisSKC4"] != null && row["AxisSKC4"].ToString() != "")
{
model.AxisSKC4 = int.Parse(row["AxisSKC4"].ToString());
}
if (row["AxisSKC5"] != null && row["AxisSKC5"].ToString() != "")
{
model.AxisSKC5 = int.Parse(row["AxisSKC5"].ToString());
}
if (row["AxisSKC6"] != null && row["AxisSKC6"].ToString() != "")
{
model.AxisSKC6 = int.Parse(row["AxisSKC6"].ToString());
}
if (row["AxisSKC7"] != null && row["AxisSKC7"].ToString() != "")
{
model.AxisSKC7 = int.Parse(row["AxisSKC7"].ToString());
}
if (row["AxisSKC8"] != null && row["AxisSKC8"].ToString() != "")
{
model.AxisSKC8 = int.Parse(row["AxisSKC8"].ToString());
}
if (row["ZZ"] != null && row["ZZ"].ToString() != "")
{
model.ZZ = int.Parse(row["ZZ"].ToString());
}
if (row["CS"] != null && row["CS"].ToString() != "")
{
model.CS = int.Parse(row["CS"].ToString());
}
if (row["XZPara"] != null && row["XZPara"].ToString() != "")
{
model.XZPara = decimal.Parse(row["XZPara"].ToString());
}
if (row["XZZZ"] != null && row["XZZZ"].ToString() != "")
{
model.XZZZ = int.Parse(row["XZZZ"].ToString());
}
if (row["ZS"] != null && row["ZS"].ToString() != "")
{
model.ZS = int.Parse(row["ZS"].ToString());
}
if (row["AxisSKC1"] != null && row["AxisSKC1"].ToString() != "")
{
model.AxisSKC1 = int.Parse(row["AxisSKC1"].ToString());
}
if (row["AxisSKC2"] != null && row["AxisSKC2"].ToString() != "")
{
model.AxisSKC2 = int.Parse(row["AxisSKC2"].ToString());
}
if (row["AxisSKC3"] != null && row["AxisSKC3"].ToString() != "")
{
model.AxisSKC3 = int.Parse(row["AxisSKC3"].ToString());
}
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public LogMainTable GetModel(string LogID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select LogID,AxisSKC4,AxisSKC5,AxisSKC6,AxisSKC7,AxisSKC8,ZZ,CS,XZPara,XZZZ,ZS,AxisSKC1,AxisSKC2,AxisSKC3 from LogMainTable ");
strSql.Append(" where LogID=@LogID ");
SqlParameter[] parameters =
{
new SqlParameter("@LogID", SqlDbType.NVarChar, 50)
};
parameters[0].Value = LogID;
LogMainTable model = new LogMainTable();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
#region 父表信息
if (ds.Tables[0].Rows[0]["LogID"] != null && ds.Tables[0].Rows[0]["LogID"].ToString() != "")
{
model.LogID = ds.Tables[0].Rows[0]["LogID"].ToString();
}
if (ds.Tables[0].Rows[0]["AxisSKC4"] != null && ds.Tables[0].Rows[0]["AxisSKC4"].ToString() != "")
{
model.AxisSKC4 = int.Parse(ds.Tables[0].Rows[0]["AxisSKC4"].ToString());
}
if (ds.Tables[0].Rows[0]["AxisSKC5"] != null && ds.Tables[0].Rows[0]["AxisSKC5"].ToString() != "")
{
model.AxisSKC5 = int.Parse(ds.Tables[0].Rows[0]["AxisSKC5"].ToString());
}
if (ds.Tables[0].Rows[0]["AxisSKC6"] != null && ds.Tables[0].Rows[0]["AxisSKC6"].ToString() != "")
{
model.AxisSKC6 = int.Parse(ds.Tables[0].Rows[0]["AxisSKC6"].ToString());
}
if (ds.Tables[0].Rows[0]["AxisSKC7"] != null && ds.Tables[0].Rows[0]["AxisSKC7"].ToString() != "")
{
model.AxisSKC7 = int.Parse(ds.Tables[0].Rows[0]["AxisSKC7"].ToString());
}
if (ds.Tables[0].Rows[0]["AxisSKC8"] != null && ds.Tables[0].Rows[0]["AxisSKC8"].ToString() != "")
{
model.AxisSKC8 = int.Parse(ds.Tables[0].Rows[0]["AxisSKC8"].ToString());
}
if (ds.Tables[0].Rows[0]["ZZ"] != null && ds.Tables[0].Rows[0]["ZZ"].ToString() != "")
{
model.ZZ = int.Parse(ds.Tables[0].Rows[0]["ZZ"].ToString());
}
if (ds.Tables[0].Rows[0]["CS"] != null && ds.Tables[0].Rows[0]["CS"].ToString() != "")
{
model.CS = int.Parse(ds.Tables[0].Rows[0]["CS"].ToString());
}
if (ds.Tables[0].Rows[0]["XZPara"] != null && ds.Tables[0].Rows[0]["XZPara"].ToString() != "")
{
model.XZPara = decimal.Parse(ds.Tables[0].Rows[0]["XZPara"].ToString());
}
if (ds.Tables[0].Rows[0]["XZZZ"] != null && ds.Tables[0].Rows[0]["XZZZ"].ToString() != "")
{
model.XZZZ = int.Parse(ds.Tables[0].Rows[0]["XZZZ"].ToString());
}
if (ds.Tables[0].Rows[0]["ZS"] != null && ds.Tables[0].Rows[0]["ZS"].ToString() != "")
{
model.ZS = int.Parse(ds.Tables[0].Rows[0]["ZS"].ToString());
}
if (ds.Tables[0].Rows[0]["AxisSKC1"] != null && ds.Tables[0].Rows[0]["AxisSKC1"].ToString() != "")
{
model.AxisSKC1 = int.Parse(ds.Tables[0].Rows[0]["AxisSKC1"].ToString());
}
if (ds.Tables[0].Rows[0]["AxisSKC2"] != null && ds.Tables[0].Rows[0]["AxisSKC2"].ToString() != "")
{
model.AxisSKC2 = int.Parse(ds.Tables[0].Rows[0]["AxisSKC2"].ToString());
}
if (ds.Tables[0].Rows[0]["AxisSKC3"] != null && ds.Tables[0].Rows[0]["AxisSKC3"].ToString() != "")
{
model.AxisSKC3 = int.Parse(ds.Tables[0].Rows[0]["AxisSKC3"].ToString());
}
#endregion 父表信息end
#region 子表信息
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("select ID,LogID,CBNo,JLZ,SK,CBZZ,UsedSKC from LogDetailTable ");
strSql2.Append(" where LogID=@LogID ");
SqlParameter[] parameters2 =
{
new SqlParameter("@LogID", SqlDbType.NVarChar, -1)
};
parameters2[0].Value = LogID;
DataSet ds2 = DbHelperSQL.Query(strSql2.ToString(), parameters2);
if (ds2.Tables[0].Rows.Count > 0)
{
#region 子表字段信息
int i = ds2.Tables[0].Rows.Count;
List <LogDetailTable> models = new List <LogDetailTable>();
LogDetailTable modelt;
for (int n = 0; n < i; n++)
{
modelt = new LogDetailTable();
if (ds2.Tables[0].Rows[n]["ID"] != null && ds2.Tables[0].Rows[n]["ID"].ToString() != "")
{
modelt.ID = int.Parse(ds2.Tables[0].Rows[n]["ID"].ToString());
}
if (ds2.Tables[0].Rows[n]["LogID"] != null && ds2.Tables[0].Rows[n]["LogID"].ToString() != "")
{
modelt.LogID = ds2.Tables[0].Rows[n]["LogID"].ToString();
}
if (ds2.Tables[0].Rows[n]["CBNo"] != null && ds2.Tables[0].Rows[n]["CBNo"].ToString() != "")
{
modelt.CBNo = int.Parse(ds2.Tables[0].Rows[n]["CBNo"].ToString());
}
if (ds2.Tables[0].Rows[n]["JLZ"] != null && ds2.Tables[0].Rows[n]["JLZ"].ToString() != "")
{
modelt.JLZ = int.Parse(ds2.Tables[0].Rows[n]["JLZ"].ToString());
}
if (ds2.Tables[0].Rows[n]["SK"] != null && ds2.Tables[0].Rows[n]["SK"].ToString() != "")
{
modelt.SK = int.Parse(ds2.Tables[0].Rows[n]["SK"].ToString());
}
if (ds2.Tables[0].Rows[n]["CBZZ"] != null && ds2.Tables[0].Rows[n]["CBZZ"].ToString() != "")
{
modelt.CBZZ = int.Parse(ds2.Tables[0].Rows[n]["CBZZ"].ToString());
}
if (ds2.Tables[0].Rows[n]["UsedSKC"] != null && ds2.Tables[0].Rows[n]["UsedSKC"].ToString() != "")
{
modelt.UsedSKC = int.Parse(ds2.Tables[0].Rows[n]["UsedSKC"].ToString());
}
models.Add(modelt);
}
model.LogDetailTables = models;
#endregion 子表字段信息end
}
#endregion 子表信息end
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据,及其子表数据
/// </summary>
public int Add(LogMainTable model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into LogMainTable(");
strSql.Append("LogID,AxisSKC4,AxisSKC5,AxisSKC6,AxisSKC7,AxisSKC8,ZZ,CS,XZPara,XZZZ,ZS,AxisSKC1,AxisSKC2,AxisSKC3)");
strSql.Append(" values (");
strSql.Append("@LogID,@AxisSKC4,@AxisSKC5,@AxisSKC6,@AxisSKC7,@AxisSKC8,@ZZ,@CS,@XZPara,@XZZZ,@ZS,@AxisSKC1,@AxisSKC2,@AxisSKC3)");
SqlParameter[] parameters =
{
new SqlParameter("@LogID", SqlDbType.NVarChar, 50),
new SqlParameter("@AxisSKC4", SqlDbType.Int, 4),
new SqlParameter("@AxisSKC5", SqlDbType.Int, 4),
new SqlParameter("@AxisSKC6", SqlDbType.Int, 4),
new SqlParameter("@AxisSKC7", SqlDbType.Int, 4),
new SqlParameter("@AxisSKC8", SqlDbType.Int, 4),
new SqlParameter("@ZZ", SqlDbType.Int, 4),
new SqlParameter("@CS", SqlDbType.Int, 4),
new SqlParameter("@XZPara", SqlDbType.Decimal, 9),
new SqlParameter("@XZZZ", SqlDbType.Int, 4),
new SqlParameter("@ZS", SqlDbType.Int, 4),
new SqlParameter("@AxisSKC1", SqlDbType.Int, 4),
new SqlParameter("@AxisSKC2", SqlDbType.Int, 4),
new SqlParameter("@AxisSKC3", SqlDbType.Int, 4)
};
parameters[0].Value = model.LogID;
parameters[1].Value = model.AxisSKC4;
parameters[2].Value = model.AxisSKC5;
parameters[3].Value = model.AxisSKC6;
parameters[4].Value = model.AxisSKC7;
parameters[5].Value = model.AxisSKC8;
parameters[6].Value = model.ZZ;
parameters[7].Value = model.CS;
parameters[8].Value = model.XZPara;
parameters[9].Value = model.XZZZ;
parameters[10].Value = model.ZS;
parameters[11].Value = model.AxisSKC1;
parameters[12].Value = model.AxisSKC2;
parameters[13].Value = model.AxisSKC3;
List <CommandInfo> sqllist = new List <CommandInfo>();
CommandInfo cmd = new CommandInfo(strSql.ToString(), parameters);
sqllist.Add(cmd);
StringBuilder strSql2;
foreach (LogDetailTable models in model.LogDetailTables)
{
strSql2 = new StringBuilder();
strSql2.Append("insert into LogDetailTable(");
strSql2.Append("LogID,CBNo,JLZ,SK,CBZZ,UsedSKC)");
strSql2.Append(" values (");
strSql2.Append("@LogID,@CBNo,@JLZ,@SK,@CBZZ,@UsedSKC)");
SqlParameter[] parameters2 =
{
new SqlParameter("@LogID", SqlDbType.NVarChar, 50),
new SqlParameter("@CBNo", SqlDbType.Int, 4),
new SqlParameter("@JLZ", SqlDbType.Int, 4),
new SqlParameter("@SK", SqlDbType.Int, 4),
new SqlParameter("@CBZZ", SqlDbType.Int, 4),
new SqlParameter("@UsedSKC", SqlDbType.Int, 4)
};
parameters2[0].Value = models.LogID;
parameters2[1].Value = models.CBNo;
parameters2[2].Value = models.JLZ;
parameters2[3].Value = models.SK;
parameters2[4].Value = models.CBZZ;
parameters2[5].Value = models.UsedSKC;
cmd = new CommandInfo(strSql2.ToString(), parameters2);
sqllist.Add(cmd);
}
return(DbHelperSQL.ExecuteSqlTran(sqllist));
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(LogMainTable model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update LogMainTable set ");
strSql.Append("AxisSKC4=@AxisSKC4,");
strSql.Append("AxisSKC5=@AxisSKC5,");
strSql.Append("AxisSKC6=@AxisSKC6,");
strSql.Append("AxisSKC7=@AxisSKC7,");
strSql.Append("AxisSKC8=@AxisSKC8,");
strSql.Append("ZZ=@ZZ,");
strSql.Append("CS=@CS,");
strSql.Append("XZPara=@XZPara,");
strSql.Append("XZZZ=@XZZZ,");
strSql.Append("ZS=@ZS,");
strSql.Append("AxisSKC1=@AxisSKC1,");
strSql.Append("AxisSKC2=@AxisSKC2,");
strSql.Append("AxisSKC3=@AxisSKC3");
strSql.Append(" where LogID=@LogID ");
SqlParameter[] parameters =
{
new SqlParameter("@LogID", SqlDbType.NVarChar, 50),
new SqlParameter("@AxisSKC4", SqlDbType.Int, 4),
new SqlParameter("@AxisSKC5", SqlDbType.Int, 4),
new SqlParameter("@AxisSKC6", SqlDbType.Int, 4),
new SqlParameter("@AxisSKC7", SqlDbType.Int, 4),
new SqlParameter("@AxisSKC8", SqlDbType.Int, 4),
new SqlParameter("@ZZ", SqlDbType.Int, 4),
new SqlParameter("@CS", SqlDbType.Int, 4),
new SqlParameter("@XZPara", SqlDbType.Decimal, 9),
new SqlParameter("@XZZZ", SqlDbType.Int, 4),
new SqlParameter("@ZS", SqlDbType.Int, 4),
new SqlParameter("@AxisSKC1", SqlDbType.Int, 4),
new SqlParameter("@AxisSKC2", SqlDbType.Int, 4),
new SqlParameter("@AxisSKC3", SqlDbType.Int, 4)
};
parameters[0].Value = model.LogID;
parameters[1].Value = model.AxisSKC4;
parameters[2].Value = model.AxisSKC5;
parameters[3].Value = model.AxisSKC6;
parameters[4].Value = model.AxisSKC7;
parameters[5].Value = model.AxisSKC8;
parameters[6].Value = model.ZZ;
parameters[7].Value = model.CS;
parameters[8].Value = model.XZPara;
parameters[9].Value = model.XZZZ;
parameters[10].Value = model.ZS;
parameters[11].Value = model.AxisSKC1;
parameters[12].Value = model.AxisSKC2;
parameters[13].Value = model.AxisSKC3;
int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
