public static bool Insert(Model.BCenter model)
{
Hashtable MyHs = new Hashtable();
MyHs = DAL.BCenter.Insert(model, MyHs);
return(DAL.CommonBase.RunHashtable(MyHs));
}
private static Model.BCenter TranEntity(DataRow dr)
{
Model.BCenter model = new Model.BCenter();
if (!string.IsNullOrEmpty(dr["MID"].ToString()))
{
model.MID = dr["MID"].ToString();
}
if (!string.IsNullOrEmpty(dr["MName"].ToString()))
{
model.MName = dr["MName"].ToString();
}
if (!string.IsNullOrEmpty(dr["Des"].ToString()))
{
model.Des = dr["Des"].ToString();
}
if (!string.IsNullOrEmpty(dr["AddDate"].ToString()))
{
model.AddDate = DateTime.Parse(dr["AddDate"].ToString());
}
if (!string.IsNullOrEmpty(dr["Flag"].ToString()))
{
model.Flag = dr["Flag"].ToString();
}
return(model);
}
public static Hashtable Insert(Model.BCenter model, Hashtable MyHs)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into BCenter(");
strSql.Append("MID,MName,Type,AddDate,Status,ValidTime,Img)");
strSql.Append(" values (");
strSql.Append("@MID,@MName,@Type,@AddDate,@Status,@ValidTime,@Img)");
SqlParameter[] parameters =
{
new SqlParameter("@MID", SqlDbType.VarChar, 20),
new SqlParameter("@MName", SqlDbType.VarChar, 20),
new SqlParameter("@Type", SqlDbType.VarChar, 10),
new SqlParameter("@AddDate", SqlDbType.DateTime),
new SqlParameter("@Status", SqlDbType.Bit, 1),
new SqlParameter("@ValidTime", SqlDbType.DateTime),
new SqlParameter("@Img", SqlDbType.Text)
};
parameters[0].Value = model.MID;
parameters[1].Value = model.MName;
parameters[2].Value = model.Type;
parameters[3].Value = model.AddDate;
parameters[4].Value = model.Status;
parameters[5].Value = model.ValidTime;
parameters[6].Value = model.Img;
MyHs.Add(strSql.ToString(), parameters);
return(MyHs);
}
/// <summary>
/// 注册股东
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected override string btnAdd_Click()
{
Model.BCenter model = new Model.BCenter();
model.MID = TModel.MID;
model.MName = TModel.MName;
model.Des = "申请报单中心";
model.AddDate = DateTime.Now;
model.Flag = "0";
if (BLL.BCenter.Insert(model))
{
BLL.Task.SendManage(TModel, "001", TModel.MName + "申请了报单中心!");//给管理员发消息
return("申请成功");
}
return("您已申请过了");
}
private static Model.BCenter TranEntity(DataRow row)
{
Model.BCenter model = new Model.BCenter();
if (row["MID"] != null)
{
model.MID = row["MID"].ToString();
}
if (row["MName"] != null)
{
model.MName = row["MName"].ToString();
}
if (row["Type"] != null)
{
model.Type = row["Type"].ToString();
}
if (row["AddDate"] != null && row["AddDate"].ToString() != "")
{
model.AddDate = DateTime.Parse(row["AddDate"].ToString());
}
if (row["Status"] != null && row["Status"].ToString() != "")
{
if ((row["Status"].ToString() == "1") || (row["Status"].ToString().ToLower() == "true"))
{
model.Status = true;
}
else
{
model.Status = false;
}
}
if (row["ValidTime"] != null && row["ValidTime"].ToString() != "")
{
model.ValidTime = DateTime.Parse(row["ValidTime"].ToString());
}
if (row["Img"] != null)
{
model.Img = row["Img"].ToString();
}
return(model);
}
public static Hashtable Insert(Model.BCenter model, Hashtable MyHs)
{
StringBuilder sb = new StringBuilder("insert into BCenter (MID,MName,Des,AddDate,Flag) ");
sb.Append("values");
sb.Append("(@MID,@MName,@Des,@AddDate,@Flag)");
SqlParameter[] parameters =
{
new SqlParameter("@MID", SqlDbType.VarChar, 20),
new SqlParameter("@MName", SqlDbType.VarChar, 10),
new SqlParameter("@Des", SqlDbType.VarChar, 50),
new SqlParameter("@AddDate", SqlDbType.DateTime, 8),
new SqlParameter("@Flag", SqlDbType.VarChar, 10)
};
parameters[0].Value = model.MID;
parameters[1].Value = model.MName;
parameters[2].Value = model.Des;
parameters[3].Value = model.AddDate;
parameters[4].Value = model.Flag;
MyHs.Add(sb.ToString(), parameters);
return(MyHs);
}
