private string SaveData() { Workflow_FormTypeEntity _Workflow_FormTypeEntity = new Workflow_FormTypeEntity(); _Workflow_FormTypeEntity.FormTypeID = Convert.ToInt32(txtFormTypeID.Value != string.Empty ? txtFormTypeID.Value : "0"); _Workflow_FormTypeEntity.FormTypeName = txtFormTypeName.Text; _Workflow_FormTypeEntity.FormTypeDesc = txtFormTypeDesc.Text; _Workflow_FormTypeEntity.DisplayOrder = Convert.ToInt32(txtDisplayOrder.Text != string.Empty ? txtDisplayOrder.Text : "99990"); _Workflow_FormTypeEntity.Useflag = chkUseFlag.Checked ? "1" : "0"; _Workflow_FormTypeEntity.Creator = userEntity.UserID; _Workflow_FormTypeEntity.CreateDate = DateTime.Now; _Workflow_FormTypeEntity.lastModifier = userEntity.UserID; _Workflow_FormTypeEntity.lastModifyDate = DateTime.Now; string sResult = "-1"; if (strOperationState == "Add") sResult = DbHelper.GetInstance().AddWorkflow_FormType(_Workflow_FormTypeEntity); else if (strOperationState == "Update") sResult = DbHelper.GetInstance().UpdateWorkflow_FormType(_Workflow_FormTypeEntity); return sResult; }
private Workflow_FormTypeEntity GetWorkflow_FormTypeFromIDataReader(DbDataReader dr) { Workflow_FormTypeEntity dt = new Workflow_FormTypeEntity(); if (dr.FieldCount > 0) { if (dr["FormTypeID"].ToString() != "" || dr["FormTypeID"] != null) dt.FormTypeID = Int32.Parse(dr["FormTypeID"].ToString()); dt.FormTypeName = dr["FormTypeName"].ToString(); dt.FormTypeDesc = dr["FormTypeDesc"].ToString(); if (dr["DisplayOrder"].ToString() != "" || dr["DisplayOrder"] != null) dt.DisplayOrder = Int32.Parse(dr["DisplayOrder"].ToString()); dt.Useflag = dr["Useflag"].ToString(); dt.Creator = dr["Creator"].ToString(); dt.CreateDate = Convert.ToDateTime(dr["CreateDate"]); dt.lastModifier = dr["lastModifier"].ToString(); dt.lastModifyDate = Convert.ToDateTime(dr["lastModifyDate"]); dr.Close(); return dt; } dr.Close(); return null; }
/// <summary> /// 新增信息 /// </summary> /// <param name="_Workflow_FormTypeEntity"></param> /// <returns>返回string "-1"表示该已经存在,否则成功 </returns> public string AddWorkflow_FormType(Workflow_FormTypeEntity _Workflow_FormTypeEntity) { //判断该记录是否已经存在 DbParameter[] prams = { MakeInParam("@FormTypeName",(DbType)SqlDbType.VarChar,50,_Workflow_FormTypeEntity.FormTypeName ), MakeInParam("@DisplayOrder",(DbType)SqlDbType.Int,4,_Workflow_FormTypeEntity.DisplayOrder ), }; string sql = " select * from [dbo].[Workflow_FormType] where FormTypeName=@FormTypeName or DisplayOrder=@DisplayOrder "; if (ExecuteDataset(CommandType.Text, sql, prams).Tables[0].Rows.Count > 0) { return "-1";//该记录已经存在 } else { DbParameter[] pramsInsert = { MakeInParam("@FormTypeName",(DbType)SqlDbType.VarChar,50,_Workflow_FormTypeEntity.FormTypeName ), MakeInParam("@FormTypeDesc",(DbType)SqlDbType.VarChar,200,_Workflow_FormTypeEntity.FormTypeDesc ), MakeInParam("@DisplayOrder",(DbType)SqlDbType.Int,4,_Workflow_FormTypeEntity.DisplayOrder ), MakeInParam("@Useflag",(DbType)SqlDbType.VarChar,50,_Workflow_FormTypeEntity.Useflag ), MakeInParam("@Creator",(DbType)SqlDbType.VarChar,50,_Workflow_FormTypeEntity.Creator ), MakeInParam("@CreateDate",(DbType)SqlDbType.DateTime,16,_Workflow_FormTypeEntity.CreateDate ), MakeInParam("@lastModifier",(DbType)SqlDbType.VarChar,50,_Workflow_FormTypeEntity.lastModifier ), MakeInParam("@lastModifyDate",(DbType)SqlDbType.DateTime,16,_Workflow_FormTypeEntity.lastModifyDate ), }; StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO [dbo].[Workflow_FormType]"); sb.Append("("); sb.Append(" [FormTypeName]"); sb.Append(",[FormTypeDesc]"); sb.Append(",[DisplayOrder]"); sb.Append(",[Useflag]"); sb.Append(",[Creator]"); sb.Append(",[CreateDate]"); sb.Append(",[lastModifier]"); sb.Append(",[lastModifyDate]"); sb.Append(") "); sb.Append(" VALUES ("); sb.Append("@FormTypeName,"); sb.Append("@FormTypeDesc,"); sb.Append("@DisplayOrder,"); sb.Append("@Useflag,"); sb.Append("@Creator,"); sb.Append("@CreateDate,"); sb.Append("@lastModifier,"); sb.Append("@lastModifyDate )"); sb.Append("select @@identity;"); ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString(); ArrayList arlst = new ArrayList(); arlst.Add("Workflow_FormType"); arlst.Add(""); arlst.Add(""); return sp_ReDisplayOrder(arlst); } }
/// <summary> /// 修改信息 /// </summary> /// <param name="_Workflow_FormTypeEntity"></param> /// <returns>返回string "-1"表示该已经存在,否则成功 </returns> public string UpdateWorkflow_FormType(Workflow_FormTypeEntity _Workflow_FormTypeEntity) { DbParameter[] pramsUpdate = { MakeInParam("@FormTypeID",(DbType)SqlDbType.Int,4,_Workflow_FormTypeEntity.FormTypeID ), MakeInParam("@FormTypeName",(DbType)SqlDbType.VarChar,50,_Workflow_FormTypeEntity.FormTypeName ), MakeInParam("@FormTypeDesc",(DbType)SqlDbType.VarChar,200,_Workflow_FormTypeEntity.FormTypeDesc ), MakeInParam("@DisplayOrder",(DbType)SqlDbType.Int,4,_Workflow_FormTypeEntity.DisplayOrder ), MakeInParam("@Useflag",(DbType)SqlDbType.VarChar,50,_Workflow_FormTypeEntity.Useflag ), MakeInParam("@lastModifier",(DbType)SqlDbType.VarChar,50,_Workflow_FormTypeEntity.lastModifier ), MakeInParam("@lastModifyDate",(DbType)SqlDbType.DateTime,23,_Workflow_FormTypeEntity.lastModifyDate ), }; StringBuilder sb = new StringBuilder(); sb.Append("Update [dbo].[Workflow_FormType]"); sb.Append(" set "); sb.Append(" [FormTypeName]=@FormTypeName,"); sb.Append(" [FormTypeDesc]=@FormTypeDesc,"); sb.Append(" [DisplayOrder]=@DisplayOrder,"); sb.Append(" [Useflag]=@Useflag,"); sb.Append(" [lastModifier]=@lastModifier,"); sb.Append(" [lastModifyDate]=@lastModifyDate "); sb.Append(" where [FormTypeID]=@FormTypeID "); sb.Append(" select @FormTypeID;"); ExecuteScalar(CommandType.Text, sb.ToString(), pramsUpdate).ToString(); ArrayList arlst = new ArrayList(); arlst.Add("Workflow_FormType"); arlst.Add(""); arlst.Add(""); return sp_ReDisplayOrder(arlst); }