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(); }