public string Insert(DefinedFormDetailData data)
{
string sqlStr;
SqlCommand cmd;
sqlStr = "Insert Into DefinedFormDetail(MasterPK,Title,AnswerType,AnswerDefine,Required" +
",Sort,CreateDate) Values(@MasterPK,@Title,@AnswerType,@AnswerDefine,@Require" +
"d,@Sort,@CreateDate) SET @QPk = SCOPE_IDENTITY()";
cmd = new SqlCommand(sqlStr, this.mCon);
cmd.Parameters.AddWithValue("@MasterPK", data.MasterPK);
cmd.Parameters.AddWithValue("@Title", data.Title);
cmd.Parameters.AddWithValue("@AnswerType", data.AnswerType);
cmd.Parameters.AddWithValue("@AnswerDefine", data.AnswerDefine);
cmd.Parameters.AddWithValue("@Required", data.Required ? "Y" : "N");
cmd.Parameters.AddWithValue("@Sort", data.Sort);
cmd.Parameters.AddWithValue("@CreateDate", data.CreateDate);
var para = new SqlParameter("@QPk", SqlDbType.Int);
para.Direction = ParameterDirection.Output;
cmd.Parameters.Add(para);
this.mCon.Open();
cmd.ExecuteNonQuery();
this.mCon.Close();
cmd.Dispose();
return(para.Value.ToString());
}
private DefinedFormDetailData GetDefindedFormDetail(SqlDataReader dr)
{
DefinedFormDetailData data = new DefinedFormDetailData();
data.PK = ((int)(dr["PK"]));
data.MasterPK = ((int)(dr["MasterPK"]));
data.Title = dr["Title"].ToString();
data.AnswerType = dr["AnswerType"].ToString();
data.AnswerDefine = dr["AnswerDefine"].ToString();
data.Required = dr["Required"].ToString() == "Y";
data.Sort = ((int)(dr["Sort"]));
data.CreateDate = ((DateTime)(dr["CreateDate"]));
return(data);
}
public string SaveDetail(DefinedFormDetailData data)
{
string pk = data.PK.ToString();
DefinedFormDetailManager ddm = new DefinedFormDetailManager();
//data.Sort = 0;
data.CreateDate = DateTime.Now;
if (data.PK == 0)
{
pk = ddm.Insert(data);
}
else
{
ddm.Update(data);
}
return(pk);
}
public string UpdateSort(string value)
{
DefinedFormDetailManager ddm = new DefinedFormDetailManager();
List <DefinedFormDetailData> datas = new List <DefinedFormDetailData>();
DefinedFormDetailData data;
string[] values = value.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
foreach (string val in values)
{
data = new DefinedFormDetailData();
var str = val.Replace("Id", "PK");
data = Element.ToElement(data, str);
datas.Add(data);
}
ddm.UpdateSortBatch(datas);
return("Y");
}
public virtual void Update(DefinedFormDetailData data)
{
string sqlStr;
SqlCommand cmd;
sqlStr = "Update DefinedFormDetail Set MasterPK= @MasterPK,Title= @Title,AnswerType= @Answ" +
"erType,AnswerDefine= @AnswerDefine,Required= @Required,Sort= @Sort,CreateDate= @" +
"CreateDate Where PK =@PK";
cmd = new SqlCommand(sqlStr, this.mCon);
cmd.Parameters.AddWithValue("@MasterPK", data.MasterPK);
cmd.Parameters.AddWithValue("@Title", data.Title);
cmd.Parameters.AddWithValue("@AnswerType", data.AnswerType);
cmd.Parameters.AddWithValue("@AnswerDefine", data.AnswerDefine);
cmd.Parameters.AddWithValue("@Required", data.Required ? "Y" : "N");
cmd.Parameters.AddWithValue("@Sort", data.Sort);
cmd.Parameters.AddWithValue("@CreateDate", data.CreateDate);
cmd.Parameters.AddWithValue("@PK", data.PK);
this.mCon.Open();
cmd.ExecuteNonQuery();
this.mCon.Close();
cmd.Dispose();
}
