public string UpDateCalendar(MyCalendar _MyCalendar) { DbParameter[] pramsUpDate = { MakeInParam("@ID",(DbType)SqlDbType.Int,4,_MyCalendar.ID), MakeInParam("@UID",(DbType)SqlDbType.VarChar,50,_MyCalendar.UID), MakeInParam("@EID",(DbType)SqlDbType.VarChar,50,_MyCalendar.EID), MakeInParam("@EName",(DbType)SqlDbType.VarChar,50,_MyCalendar.EName), MakeInParam("@STime",(DbType)SqlDbType.VarChar,50,_MyCalendar.STime), MakeInParam("@ETime",(DbType)SqlDbType.VarChar,50,_MyCalendar.ETime), MakeInParam("@CTime",(DbType)SqlDbType.VarChar,50,_MyCalendar.CTime), MakeInParam("@MEMO",(DbType)SqlDbType.VarChar,50,_MyCalendar.MEMO), }; StringBuilder sb = new StringBuilder(); sb.Append("UpDate [dbo].[Calendar]"); sb.Append(" set "); sb.Append(" [ID]=@ID,"); sb.Append(" [UID]=@UID,"); sb.Append(" [EID]=@EID,"); sb.Append(" [EName]=@EName,"); sb.Append(" [STime]=@STime,"); sb.Append(" [ETime]=@ETime,"); sb.Append(" [CTime]=@CTime,"); sb.Append(" [MEMO]=@MEMO"); sb.Append(" where [UID]=@UID and [EID]=@EID"); sb.Append(" select @ID "); return ExecuteScalar(CommandType.Text, sb.ToString(), pramsUpDate).ToString(); }
private MyCalendar GetCalendarFromIDataReader(DbDataReader dr) { MyCalendar dt = new MyCalendar(); if (dr.FieldCount > 0) { dt.CTime = dr["CTime"].ToString(); dt.EID = dr["EID"].ToString(); dt.EName = dr["EName"].ToString(); dt.ETime = dr["ETime"].ToString(); dt.ID = Int32.Parse(dr["ID"].ToString()); dt.MEMO = dr["MEMO"].ToString(); dt.STime = dr["STime"].ToString(); dt.UID = dr["UID"].ToString(); dr.Close(); return dt; } dr.Close(); return null; }
public string AddNewsCalender(MyCalendar _MyCalendar) { DbParameter[] pramsInsert = { MakeInParam("@ID",(DbType)SqlDbType.Int,4,_MyCalendar.ID), MakeInParam("@UID",(DbType)SqlDbType.VarChar,50,_MyCalendar.UID), MakeInParam("@EID",(DbType)SqlDbType.VarChar,50,_MyCalendar.EID), MakeInParam("@EName",(DbType)SqlDbType.VarChar,50,_MyCalendar.EName), MakeInParam("@STime",(DbType)SqlDbType.VarChar,50,_MyCalendar.STime), MakeInParam("@ETime",(DbType)SqlDbType.VarChar,50,_MyCalendar.ETime), MakeInParam("@CTime",(DbType)SqlDbType.VarChar,50,_MyCalendar.CTime), MakeInParam("@MEMO",(DbType)SqlDbType.VarChar,50,_MyCalendar.MEMO), }; StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO [dbo].[Calendar]"); sb.Append("([ID]"); sb.Append(",[UID]"); sb.Append(",[EID]"); sb.Append(",[EName]"); sb.Append(",[STime]"); sb.Append(",[ETime]"); sb.Append(",[CTime]"); sb.Append(",[MEMO]"); sb.Append(")"); sb.Append("VALUES"); sb.Append("(@ID"); sb.Append(",@UID"); sb.Append(",@EID"); sb.Append(",@EName"); sb.Append(",@STime"); sb.Append(",@ETime"); sb.Append(",@CTime"); sb.Append(",@MEMO"); sb.Append(")"); sb.Append(" select @ID;"); return ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString(); }