using (SqlConnection conn = new SqlConnection(DbConnString))
{
conn.Open();
SqlDataAdapter sd = new SqlDataAdapter();
sd.SelectCommand =
new SqlCommand(@"select WMStoreID,WMStoreAreaID,WMStoreRackID,WMStoreLocationCode,WMStoreArrayX,WMStoreArrayY,WMStoreLocationDesc,CreateTime,WMUseStatus from WMStoreLocation", conn);
sd.InsertCommand =
new SqlCommand(
@"insert into WMStoreLocation(WMStoreID,WMStoreAreaID,WMStoreRackID,WMStoreLocationCode,WMStoreArrayX,WMStoreArrayY,WMStoreLocationDesc,CreateTime,WMUseStatus) values(@WMStoreID,@WMStoreAreaID,@WMStoreRackID,@WMStoreLocationCode,@WMStoreArrayX,@WMStoreArrayY,'',GETDATE(),1)",
conn);
sd.InsertCommand.Parameters.Add("@WMStoreID", SqlDbType.Int, 32, "WMStoreID");
sd.InsertCommand.Parameters.Add("@WMStoreAreaID", SqlDbType.Int, 32, "WMStoreAreaID");
sd.InsertCommand.Parameters.Add("@WMStoreRackID", SqlDbType.Int, 32, "WMStoreRackID");
sd.InsertCommand.Parameters.Add("@WMStoreLocationCode", SqlDbType.VarChar, 10, "WMStoreLocationCode");
sd.InsertCommand.Parameters.Add("@WMStoreArrayX", SqlDbType.Int, 32, "WMStoreArrayX");
sd.InsertCommand.Parameters.Add("@WMStoreArrayY", SqlDbType.Int, 32, "WMStoreArrayY");
//sd.InsertCommand.Parameters.Add("@WMStoreLocationDesc", SqlDbType.VarChar, 100, "WMStoreLocationDesc");
//sd.InsertCommand.Parameters.Add("@CreateTime", SqlDbType.DateTime, 32, "CreateTime");
//sd.InsertCommand.Parameters.Add("@WMUseStatus", SqlDbType.Int, 32, "WMUseStatus");
sd.InsertCommand.UpdatedRowSource = UpdateRowSource.None;
//sd.UpdateBatchSize = 0;
DataSet dataset = new DataSet();
sd.Fill(dataset);
int total = 1;
string incStr = "";
for (int i = 0; i < req.WMStoreArrayLines; i++)
{
for (int j = 0; j < req.WMStoreArrayRows; j++)
{
if (total < 10)
{
incStr = "0" + total.ToString();
}
else
{
incStr = total.ToString();
}
DataRow row = dataset.Tables[0].NewRow();
row["WMStoreID"] = req.WMStoreID;
row["WMStoreAreaID"] = req.WMStoreAreaID;
row["WMStoreRackID"] = req.WMStoreRackID;
row["WMStoreLocationCode"] = req.WMStoreAreaCode + incStr;
row["WMStoreArrayX"] = i;
row["WMStoreArrayY"] = j;
//row["WMStoreLocationDesc"] ="ddd";
//row["CreateTime"] = DateTime.Now;
//row["WMUseStatus"] = 1;
dataset.Tables[0].Rows.Add(row);
total++;
}
}
sd.Update(dataset.Tables[0]);
dataset.Tables[0].Clear();
sd.Dispose();
dataset.Dispose();
conn.Close();
}
{
conn.Open();
SqlDataAdapter sd = new SqlDataAdapter();
sd.SelectCommand =
new SqlCommand(@"select WMStoreID,WMStoreAreaID,WMStoreRackID,WMStoreLocationCode,WMStoreArrayX,WMStoreArrayY,WMStoreLocationDesc,CreateTime,WMUseStatus from WMStoreLocation", conn);
sd.InsertCommand =
new SqlCommand(
@"insert into WMStoreLocation(WMStoreID,WMStoreAreaID,WMStoreRackID,WMStoreLocationCode,WMStoreArrayX,WMStoreArrayY,WMStoreLocationDesc,CreateTime,WMUseStatus) values(@WMStoreID,@WMStoreAreaID,@WMStoreRackID,@WMStoreLocationCode,@WMStoreArrayX,@WMStoreArrayY,'',GETDATE(),1)",
conn);
sd.InsertCommand.Parameters.Add("@WMStoreID", SqlDbType.Int, 32, "WMStoreID");
sd.InsertCommand.Parameters.Add("@WMStoreAreaID", SqlDbType.Int, 32, "WMStoreAreaID");
sd.InsertCommand.Parameters.Add("@WMStoreRackID", SqlDbType.Int, 32, "WMStoreRackID");
sd.InsertCommand.Parameters.Add("@WMStoreLocationCode", SqlDbType.VarChar, 10, "WMStoreLocationCode");
sd.InsertCommand.Parameters.Add("@WMStoreArrayX", SqlDbType.Int, 32, "WMStoreArrayX");
sd.InsertCommand.Parameters.Add("@WMStoreArrayY", SqlDbType.Int, 32, "WMStoreArrayY");
//sd.InsertCommand.Parameters.Add("@WMStoreLocationDesc", SqlDbType.VarChar, 100, "WMStoreLocationDesc");
//sd.InsertCommand.Parameters.Add("@CreateTime", SqlDbType.DateTime, 32, "CreateTime");
//sd.InsertCommand.Parameters.Add("@WMUseStatus", SqlDbType.Int, 32, "WMUseStatus");
sd.InsertCommand.UpdatedRowSource = UpdateRowSource.None;
//sd.UpdateBatchSize = 0;
DataSet dataset = new DataSet();
sd.Fill(dataset);
int total = 1;
string incStr = "";
for (int i = 0; i < req.WMStoreArrayLines; i++)
{
for (int j = 0; j < req.WMStoreArrayRows; j++)
{
if (total < 10)
{
incStr = "0" + total.ToString();
}
else
{
incStr = total.ToString();
}
DataRow row = dataset.Tables[0].NewRow();
row["WMStoreID"] = req.WMStoreID;
row["WMStoreAreaID"] = req.WMStoreAreaID;
row["WMStoreRackID"] = req.WMStoreRackID;
row["WMStoreLocationCode"] = req.WMStoreAreaCode + incStr;
row["WMStoreArrayX"] = i;
row["WMStoreArrayY"] = j;
//row["WMStoreLocationDesc"] ="ddd";
//row["CreateTime"] = DateTime.Now;
//row["WMUseStatus"] = 1;
dataset.Tables[0].Rows.Add(row);
total++;
}
}
sd.Update(dataset.Tables[0]);
dataset.Tables[0].Clear();
sd.Dispose();
dataset.Dispose();
conn.Close();
}