public string deleteDate(SQLParameter Parameter)
{
StringBuilder SQLString = new StringBuilder();
SQLString.Append(@"Delete " + TBName + " Where 1=1");
foreach (var pa in Parameter.WhereCondition)
{
SQLString.Append(string.Concat(" And " + pa.Key + " =" + pa.Value));
}
bool Result = ExcuteAction(Conn, SQLString.ToString());
if (Result)
{
return("刪除成功!");
}
else
{
return("刪除失敗!");
}
}
public string editData(SQLParameter Parameter)
{
StringBuilder SQLString = new StringBuilder();
SQLString.Append(string.Concat("Update " + TBName));
SQLString.Append(" Set ");
string ConnetSetValue = string.Empty;
foreach (var pa in Parameter.SetActionValue)
{
if (!string.IsNullOrEmpty(ConnetSetValue))
{
ConnetSetValue += ",";
}
ConnetSetValue += string.Concat(pa.Key + " = " + "@" + pa.Key);
}
SQLString.Append(string.Concat(ConnetSetValue));
ExcuteAction(Conn, SQLString.ToString(), Parameter);
return(null);
}
public string addData(SQLParameter Parameter)
{
StringBuilder SQLString = new StringBuilder();
SQLString.Append(string.Concat("INSERT INTO " + TBName));
SQLString.Append(" VALUES( ");
string ConnetSetValue = string.Empty;
foreach (var pa in Parameter.SetActionValue)
{
if (!string.IsNullOrEmpty(ConnetSetValue))
{
ConnetSetValue += ",";
}
ConnetSetValue += string.Concat("@" + pa.Key);
}
SQLString.Append(string.Concat(ConnetSetValue + " )"));
ExcuteAction(Conn, SQLString.ToString(), Parameter);
return(null);
}
protected bool ExcuteAction(SqlConnection Conn, string SQLString, SQLParameter Parameter = null)
{
using (SqlConnection myConn = Conn)
{
myConn.Open();
SqlTransaction tran = myConn.BeginTransaction();
try
{
int result = 0;
using (SqlCommand cmd = new SqlCommand(SQLString, myConn, tran))
{
if (Parameter != null && Parameter.SetActionValue.Count > 0)
{
foreach (var pa in Parameter.SetActionValue)
{
cmd.Parameters.AddWithValue(pa.Key, pa.Value);
}
}
result = cmd.ExecuteNonQuery();
}
tran.Commit();//無錯誤 commit
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
tran.Rollback();//錯誤 rollback
return(false);
}
finally
{
Conn.Close();
}
}
}
/// <summary>
/// 查詢Tabel TB_Calendar
/// </summary>
/// <param name="Parameter"></param>
/// <returns></returns>
public DataTable getData(SQLParameter Parameter = null)
{
string SqlString = combinationQuerySQLString(Parameter, TBName);
return(QueryExcute(Conn, SqlString.ToString()));
}
public string editData(SQLParameter Parameter)
{
throw new NotImplementedException();
}